package indi.jp.project.business.yunying.dao;

import indi.jp.project.business.yunying.entity.MaterialFiled;
import indi.jp.project.business.yunying.entity.MaterialFiledItem;
import org.apache.ibatis.annotations.Mapper;

import java.sql.SQLException;
import java.util.List;

/**
 * 耗材申请DAO
 *
 * @author jiangping
 * @date 2022/5/17
 */
@Mapper
public interface MaterialFiledDAO {

    List<MaterialFiled> queryList(MaterialFiled materialFiled) throws SQLException;

    int queryCount(MaterialFiled materialFiled) throws SQLException;

    void insert(MaterialFiled materialFiled) throws SQLException;

    void update(MaterialFiled materialFiled) throws SQLException;

    MaterialFiled findById(String id) throws SQLException;

    List<MaterialFiledItem> queryItems(String billId, String projectId) throws SQLException;

    void deleteById(String id) throws SQLException;

    void deleteItemByBillId(String billId) throws SQLException;

    void insertItems(List<MaterialFiledItem> list) throws SQLException;

    int getMatCount(String projectCode, String matCode) throws SQLException;

}
